Model Table CAT ASSORTMENT NODE

This model dimension represents Category Assortment Node and is based on the IFS Cloud dimension DIM_PROC_CAT_ASSORTMNT_NODE. All models that refer to this dimension will have the attributes and hierarchies as described below.

Attributes

AttributeDescription (where applicable)
Assortment CodeRepresents the Code of the Assortment
DescriptionRepresents the Description of the Assortment Node
L1Represents Level 1 in the Assortment Structure. Shown as Node Code - Description of the level.
L10Represents Level 10 in the Assortment Structure. Shown as Node Code - Description of the level.
L2Represents Level 2 in the Assortment Structure. Shown as Node Code - Description of the level.
L3Represents Level 3 in the Assortment Structure. Shown as Node Code - Description of the level.
L4Represents Level 4 in the Assortment Structure. Shown as Node Code - Description of the level.
L5Represents Level 5 in the Assortment Structure. Shown as Node Code - Description of the level.
L6Represents Level 6 in the Assortment Structure. Shown as Node Code - Description of the level.
L7Represents Level 7 in the Assortment Structure. Shown as Node Code - Description of the level.
L8Represents Level 8 in the Assortment Structure. Shown as Node Code - Description of the level.
L9Represents Level 9 in the Assortment Structure. Shown as Node Code - Description of the level.
Node CodeRepresents the Code of the Assortment Node

Hierarchies

HierarchyLevel
CatAssortHy
Assortment Code
L1
L2
L3
L4
L5
L6
L7
L8
L9
L10

USED BY MODEL(S)

Model Name
Procurement

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
CAT ASSORTMENT NODEDIM_PROC_CAT_ASSORTMNT_NODE_TMDIM_PROC_CAT_ASSORTMNT_NODE_BIDIM_PROC_CAT_ASSORTMNT_NODEOn Line